package com.pzh.guli.service.user.mapper;

import com.pzh.guli.service.user.pojo.Member;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author xzh
 * @since 2022-07-19
 */
@Mapper
public interface MemberMapper extends BaseMapper<Member> {
    @Select("SELECT COUNT(*)\n" +
            " FROM ucenter_member\n" +
            " WHERE DATE(gmt_create) = #{day}")
    Integer selectRegisterNumByDay(@Param("day") String day);
}
